white paper

SSAS Tabular as Analytical Engine

This article describes the pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it.  Read more

white paper

The Many-to-Many Revolution

This white paper explores many different uses of many-to-many relationships in both SQL Server Analysis Services Multidimensional and Tabular models.  Read more

Learn how to write DAX queries and how to manipulate tables in DAX measures and calculated columns.  Read more

white paper

Using Tabular Models in a Large-scale Commercial Solution

Analysis Services Tabular can be used in large-scale solutions and SQLBI already helped several companies in the challenging effort of defining a reliable and scalable architecture, designing the right data model and optimizing the queries. One of these stories is…  Read more

The SQLBI Methodology defines architecture and implementation of advanced BI solutions using Microsoft SQL Server, SQL Server Analysis Services and – more generally – the Microsoft suite for Business Intelligence.  Read more

This white paper describes how to use and optimizing DirectQuery with Analysis Services Tabular.  Read more

white paper

Understanding Distinct Count in DAX Query Plans

Distinct Count calculations in DAX are very fast compared to other engines. But when you have a large number of values, performance might be different depending on the query you write.  Read more

Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data.  Read more